/*
Navicat SQL Server Data Transfer

Source Server         : 192Test
Source Server Version : 105000
Source Host           : 10.82.160.192:1433
Source Database       : Bridge0606
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2013-06-24 18:09:37
*/


-- ----------------------------
-- Table structure for [dbo].[T_AR_OtherBill]
-- ----------------------------
DROP TABLE [dbo].[T_AR_OtherBill]
GO
CREATE TABLE [dbo].[T_AR_OtherBill] (
[FNumber] nvarchar(100) NULL ,
[FBillDate] datetime NULL ,
[FAmount] numeric(20,2) NULL ,
[FCreatorID] nvarchar(100) NULL ,
[FID] nvarchar(100) NOT NULL 
)


GO

-- ----------------------------
-- Records of T_AR_OtherBill
-- ----------------------------
INSERT INTO [dbo].[T_AR_OtherBill] ([FNumber], [FBillDate], [FAmount], [FCreatorID], [FID]) VALUES (N'Ap-001', N'2013-06-24 00:00:00.000', N'200.00', N'test', N'1372068090856AAAGD');
GO
INSERT INTO [dbo].[T_AR_OtherBill] ([FNumber], [FBillDate], [FAmount], [FCreatorID], [FID]) VALUES (N'Ap-002', N'2013-06-25 00:00:00.000', N'160.00', N'test', N'1372068090883AAAJE');
GO

-- ----------------------------
-- Table structure for [dbo].[T_AR_OtherBillEntry]
-- ----------------------------
DROP TABLE [dbo].[T_AR_OtherBillEntry]
GO
CREATE TABLE [dbo].[T_AR_OtherBillEntry] (
[FMaterial] nvarchar(100) NULL ,
[FSeq] int NULL ,
[FParentID] nvarchar(100) NULL ,
[FID] nvarchar(100) NOT NULL ,
[FAmount] numeric(20,2) NULL 
)


GO

-- ----------------------------
-- Records of T_AR_OtherBillEntry
-- ----------------------------
INSERT INTO [dbo].[T_AR_OtherBillEntry] ([FMaterial], [FSeq], [FParentID], [FID], [FAmount]) VALUES (N'M01', N'1', N'1372068090856AAAGD', N'1372068090856AAAHH', N'80.00');
GO
INSERT INTO [dbo].[T_AR_OtherBillEntry] ([FMaterial], [FSeq], [FParentID], [FID], [FAmount]) VALUES (N'M02', N'2', N'1372068090856AAAGD', N'1372068090856AAAIE', N'120.00');
GO
INSERT INTO [dbo].[T_AR_OtherBillEntry] ([FMaterial], [FSeq], [FParentID], [FID], [FAmount]) VALUES (N'M03', N'1', N'1372068090883AAAJE', N'1372068090883AABAA', N'160.00');
GO

-- ----------------------------
-- Indexes structure for table T_AR_OtherBill
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [dbo].[T_AR_OtherBill]
-- ----------------------------
ALTER TABLE [dbo].[T_AR_OtherBill] ADD PRIMARY KEY ([FID])
GO

-- ----------------------------
-- Indexes structure for table T_AR_OtherBillEntry
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [dbo].[T_AR_OtherBillEntry]
-- ----------------------------
ALTER TABLE [dbo].[T_AR_OtherBillEntry] ADD PRIMARY KEY ([FID])
GO
